SD - Deepak -Prudvi - 2017-07 -15 - 45552 - Spec - ABAP Sales orders creation to relieve inventory in SAP (Babu by 2017-08-04) #SalesDistribution #salesorders
SPECIFICATIONS
45552-Spec- ABAP Sales orders creation to relieve inventory in SAP
Purpose
Create sales order ZJRF to relive inventory from SAP using plant 0146, sales org 1300 and eComm customer. Also create returns sales orders ZJRR to bring in inventory for the customer returns.
Admin Info
| Purpose |
To create ECOMM sales orders ie., ZJRF and ZJRR for 1300 and 1800 sales org with plant 0146 |
| Requested By |
Babu Lankipally |
| Spec Created By |
Deepak Yasam |
| pec Created Date |
07/15/2017 |
| Spec QA by |
Surya Basa |
| Objects |
|
| Document Status |
WIP |
Estimates
| Sl.No |
Activity |
Estimation in Hours |
| 1 |
Research |
12 |
| 2 |
Documentation |
08 |
| 3 |
Development/ Config |
80 |
| 4 |
Unit test in DEV |
40 |
| 5 |
Unit test in QUA |
10 |
| 6 |
Other activity |
|
| TOTAL |
150 |
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]None
Documents
[Attach any document(s) received for the requirement(s)]NWERHYBR-503895452-010817-1212-18792.pdf
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
| Sl. |
Change Details |
Requested By |
Requested On |
Notes if any |
| 1 |
For the error logs in the spool an email should be triggered for the respective email group in TVARVC variable |
Babu Vanamali |
08/05/2017 |
|
| 2 |
Radio button option should be provided for front end program execution and default ERE order reason for ZJRR document types. |
Babu Vanamali |
08/20/2017 |
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]A new program is required to create ZJRF and ZJRR Ecomm SO's with the desired file from the directory.
In Scope:
[List the activities to be included in scope]The Ecomm SO's are created only for 0146 plant but not for other SO's .
Out of Scope:
[Out of scope activities]Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
1. A program should be developed to read the file (.csv format) from the directory.
2. The file should be created with below fields.
| Ord type |
Order Country |
Po |
RDD |
UPC |
Quantity |
4. The program should work both for standard and IC SO's.
5. The SO's should be created for 1300 (ZJRF/ZJRR) and 1800 (ZJRF/ZJRR) s.ogs.
6. If the country in the file is CA , then the SO should be created in 1800,10,00 sales area and plant 0146 (IC scenario).This would be applicable for both ZJRF and ZJRR doc types.
Configuration:
1. C1800 customer should be created and assigned as internal customer to 1800 sales org.
2. The order reason ERE should be created and assigned to 1300/1800 sales org for ZJRR document type.
3. The plant 0146 should be assigned to 1800,10,00 sales area for inter company process.
Auto picking for the deliveries:
1. As ZJRF is rush order , the auto delivery is created.
2. The routine 904 should be modified to trigger the auto picking for ZJRF doc type for both 1300,1800 s.orgs.
Test Plan
[List test scenarios/cases to be executed here]| Test ID |
Test Scenario |
Expected result |
| SD-001 |
ZJRF SO with US as country and single PO number |
The ZJRF SO should be created with 0146 plant in 1300 sales org |
| SD-002 |
ZJRF SO with US as country ,single PO number and duplicate sizes. |
The ZJRF SO should be created with 0146 plant in 1300 sales org with cumulative qunatities of the duplicate sizes |
| SD-003 |
ZJRF SO with US as country and multiple PO number's |
The ZJRF SO should be created by considering the PO number of first line in the file. |
| SD-004 |
ZJRF SO with US as country ,single PO number ,invalid and duplicate sizes. |
The error log should be displayed that ' Invalid UPC exists in the respective file'. An email should be sent to the email group. |
| SD-005 |
ZJRF SO with CA as country and single PO number |
The ZJRF SO is created with 0146 plant in 1800 sales org |
| SD-006 |
ZJRF SO with CA as country ,single PO number and duplicate sizes. |
The ZJRF SO is created with 0146 plant in 1800 sales org with cumulative qunatities of the duplicate sizes |
| SD-007 |
ZJRF SO with CA as country ,single PO number ,invalid and duplicate sizes. |
The error log should be displayed that ' Invalid UPC exists in the respective file' An email should be sent to the email group |
| SD-008 |
ZJRF SO with CA as country and multiple PO number's |
The ZJRF SO should be created by considering the PO number of first line in the file. |
| SD-009 |
Test SD-001 to SD-008 at once with different files in the directory |
The results of SD-001 to SD-008 should be displayed in the spool |
| SD-010 |
ZJRR SO with US as country and single PO number |
The ZJRR SO should be created with 0146 plant in 1300 sales org |
| SD-011 |
ZJRR SO with US as country ,single PO number and duplicate sizes. |
The ZJRR SO should be created with 0146 plant in 1300 sales org with cumulative qunatities of the duplicate sizes |
| SD-012 |
ZJRR SO with US as country and multiple PO number's |
The ZJRR SO should be created by considering the PO number of first line in the file. |
| SD-013 |
ZJRR SO with US as country ,single PO number ,invalid and duplicate sizes. |
The error log should be displayed that ' Invalid UPC exists in the respective file'. An email should be sent to the email group |
| SD-014 |
ZJRR SO with CA as country and single PO number |
The ZJRR SO is created with 0146 plant in 1800 sales org |
| SD-015 |
ZJRR SO with CA as country ,single PO number and duplicate sizes. |
The ZJRR SO is created with 0146 plant in 1800 sales org with cumulative qunatities of the duplicate sizes |
| SD-016 |
ZJRR SO with CA as country ,single PO number ,invalid and duplicate sizes. |
The error log should be displayed that ' Invalid UPC exists in the respective file'. An email should be sent to the email group |
| SD-017 |
ZJRR SO with CA as country and multiple PO number's |
The ZJRF SO should be created by considering the PO number of first line in the file. |
| SD-018 |
Test SD-010 to SD-018 at once with different files in the directory |
The results of SD-010 to SD-018 should be displayed in the spool |
Solution Details
[Provide complete technical details for configuration or programming here]
1. The program ZSD_ECOM_SO_INVRELEIVE is created as below.
2. The C1800 is assigned as internal customer as below.
3. ERE order reason is created and assigned as below.
4. Output routine changes are done as below.
Issues
[List Issues / Bugs identified in configuration or development]